package cn.ac.siom.query.dao;

import cn.ac.siom.query.vo.Tab_Thesis;
import cn.ac.siom.query.vo.resultType_jl;

import java.sql.SQLException;
import java.util.List;

public interface ITab_ThesisDao extends IDAO<String, Tab_Thesis> {


    List<Tab_Thesis> findReport() throws SQLException;

    List<Tab_Thesis> findBookSection() throws SQLException;

    List<Tab_Thesis> findJournal() throws SQLException;

    List<Tab_Thesis> findConference() throws SQLException;

    List<Tab_Thesis> findNo(Integer id) throws SQLException;

    List<Tab_Thesis> findSearch(Integer rownum, Integer page_id, String keywords) throws SQLException;

    List<Tab_Thesis> findPage(Integer rownum, Integer page_id, String keywords) throws SQLException;

    Integer findCount(String keywords) throws SQLException;

    Integer searchCount(String keywords) throws SQLException;

    Tab_Thesis list_reference(Integer i_id) throws SQLException;

    List<Tab_Thesis> findNO_tj(Integer i_id) throws SQLException;

    List<Tab_Thesis> findPage_tj(Integer rownum, Integer page_id) throws SQLException;

    Integer findCount_tj() throws SQLException;

    List<Tab_Thesis> find_Bybooks(String id) throws SQLException;

    List<Tab_Thesis> findSearch_jl(Integer page_id, String keywords, Integer type, String mold) throws SQLException;

    List<resultType_jl> searchCount_jl(String keywords, String mold) throws SQLException;

    Integer CountPage_jl(String keywords, String value, Integer type) throws SQLException;

    List<Tab_Thesis> findNO_kj(Integer i_id) throws SQLException;

    List<Tab_Thesis> findPage_kj(Integer rownum, Integer page_id) throws SQLException;

    Integer findCount_kj() throws SQLException;

    List<Tab_Thesis> finhome_kj() throws SQLException;

    // by hx
    List<Tab_Thesis> search1(Integer page_id, String mold, Integer type) throws SQLException;

    Integer count1() throws SQLException;

    List<resultType_jl> stat1(String mold) throws SQLException;

    List<Tab_Thesis> search2(Integer page_id, String mold, Integer type) throws SQLException;

    Integer count2() throws SQLException;

    List<resultType_jl> stat2(String mold) throws SQLException;

    List<Tab_Thesis> search3(Integer page_id, String mold, Integer type) throws SQLException;

    Integer count3() throws SQLException;

    List<resultType_jl> stat3(String mold) throws SQLException;

    List<Tab_Thesis> search4(Integer page_id, String mold, Integer type) throws SQLException;

    Integer count4() throws SQLException;

    List<resultType_jl> stat4(String mold) throws SQLException;

    List<Tab_Thesis> search5(Integer page_id, String mold, Integer type) throws SQLException;

    Integer count5() throws SQLException;

    List<resultType_jl> stat5(String mold) throws SQLException;

    List<Tab_Thesis> combSearch(Integer page_id, String title, String author, String publisher, String metting, String op1, String op2, String op3) throws SQLException;

    Integer combSearchCount(Integer page_id, String title, String author, String publisher, String metting, String op1, String op2, String op3) throws SQLException;

    List<resultType_jl> combSearchStat(String title, String author, String publisher, String metting, String op1, String op2, String op3, String mold) throws SQLException;

    List<Tab_Thesis> selectWordCount() throws SQLException;
}
